﻿using System;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Ink;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using System.ComponentModel;
using HCMServices.DTO;

namespace HCMServices.DAO
{
    /// <summary>
    /// This class uses for connect to database 
    /// </summary>
    public class MyDataContext : DataContext
    {
        /// <summary>
        /// Constructor of class
        /// </summary>
        /// <param name="connectString">String indentify how to connect database</param>
        public MyDataContext(string connectString)
            : base(connectString)
        {
        }

        public static int DefaultNumber = 0;

        // Specify a table for DuLieu Items
        public Table<DULIEU> Data;

        // Specify a table for DichVu Items
        public Table<DICHVU> Service;
        public Table<TUKHOADICHVU> KeyService;

        public Table<TINHTHANH> City;
        public Table<TUKHOATINHTHANH> KeyCity;

        public Table<QUANHUYEN> District;
        public Table<TUKHOAQUANHUYEN> KeyDistrict;

        public Table<TENDIADIEM> PlaceName;
        public Table<TUKHOADIADIEM> KeyPlaceName;

        public Table<DUONG> Street;
        public Table<TUKHOADUONG> KeyStreet;

        public Table<PHUONG> Ward;
        public Table<TUKHOAPHUONG> KeyWard;

        public Table<CHITIET_DULIEU> DetailData;
        public Table<CHITIETDICHVU> DetailService;
    }
}